
CREATE TABLE sys_dict (
 [id] nvarchar(36) NOT NULL,
 [code] nvarchar(20) NOT NULL,
 [name] nvarchar(50) NOT NULL,
 [create_time] bigint NULL,
 [update_time] bigint NULL,
 [remarks] nvarchar(255) NULL
)

GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'编码',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict',
'COLUMN', N'code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'名称',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict',
'COLUMN', N'name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict',
'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改时间',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict',
'COLUMN', N'update_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict',
'COLUMN', N'remarks'
GO

EXEC sp_addextendedproperty
'MS_Description', N'系统字典',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict'
GO


CREATE TABLE sys_dict_details (
 [id] nvarchar(36) NOT NULL,
 [dict_code] nvarchar(36) NOT NULL,
 [name] nvarchar(50) NOT NULL,
 [sort] int NOT NULL,
 [value] nvarchar(20) NOT NULL,
 [create_time] bigint NULL,
 [update_time] bigint NULL,
 [remarks] nvarchar(255) NULL
)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict_details',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'系统字典编码',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict_details',
'COLUMN', N'dict_code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'名称',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict_details',
'COLUMN', N'name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'排序',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict_details',
'COLUMN', N'sort'
GO

EXEC sp_addextendedproperty
'MS_Description', N'值(存入业务表值)',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict_details',
'COLUMN', N'value'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict_details',
'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改时间',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict_details',
'COLUMN', N'update_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict_details',
'COLUMN', N'remarks'
GO

EXEC sp_addextendedproperty
'MS_Description', N'系统字典详情',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict_details'
GO

CREATE TABLE sys_log (
 [id] nvarchar(36) NOT NULL,
 [title] nvarchar(50) NULL,
 [operation] nvarchar(50) NULL,
 [username] nvarchar(50) NULL,
 [level] nvarchar(10) NULL,
 [mode] nvarchar(10) NULL,
 [method] nvarchar(100) NULL,
 [ip] nvarchar(20) NULL,
 [path] nvarchar(100) NULL,
 [browser] nvarchar(255) NULL,
 [create_time] bigint NULL,
 [data] nvarchar(max) NULL
)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'sys_log',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'标题',
'SCHEMA', N'dbo',
'TABLE', N'sys_log',
'COLUMN', N'title'
GO

EXEC sp_addextendedproperty
'MS_Description', N'操作',
'SCHEMA', N'dbo',
'TABLE', N'sys_log',
'COLUMN', N'operation'
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户名',
'SCHEMA', N'dbo',
'TABLE', N'sys_log',
'COLUMN', N'username'
GO

EXEC sp_addextendedproperty
'MS_Description', N'等级',
'SCHEMA', N'dbo',
'TABLE', N'sys_log',
'COLUMN', N'level'
GO

EXEC sp_addextendedproperty
'MS_Description', N'请求方式(post,get...)',
'SCHEMA', N'dbo',
'TABLE', N'sys_log',
'COLUMN', N'mode'
GO

EXEC sp_addextendedproperty
'MS_Description', N'请求方法',
'SCHEMA', N'dbo',
'TABLE', N'sys_log',
'COLUMN', N'method'
GO

EXEC sp_addextendedproperty
'MS_Description', N'ip地址',
'SCHEMA', N'dbo',
'TABLE', N'sys_log',
'COLUMN', N'ip'
GO

EXEC sp_addextendedproperty
'MS_Description', N'接口路径',
'SCHEMA', N'dbo',
'TABLE', N'sys_log',
'COLUMN', N'path'
GO

EXEC sp_addextendedproperty
'MS_Description', N'浏览器信息',
'SCHEMA', N'dbo',
'TABLE', N'sys_log',
'COLUMN', N'browser'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间（秒）',
'SCHEMA', N'dbo',
'TABLE', N'sys_log',
'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'系统日志表',
'SCHEMA', N'dbo',
'TABLE', N'sys_log'
GO

CREATE TABLE sys_power (
 [id] nvarchar(36) NOT NULL,
 [name] nvarchar(50) NOT NULL,
 [sort] int NULL,
 [type] tinyint DEFAULT 0 NOT NULL,
 [url] nvarchar(200) NULL,
 [path] nvarchar(200) NULL,
 [cache] bit DEFAULT 0 NOT NULL,
 [icon] nvarchar(20) NULL,
 [parent_id] nvarchar(36) NOT NULL,
 [parent_ids] nvarchar(200) NOT NULL,
 [create_time] bigint NOT NULL,
 [update_time] bigint NOT NULL,
 [remarks] nvarchar(255) NULL
)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'sys_power',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'名称',
'SCHEMA', N'dbo',
'TABLE', N'sys_power',
'COLUMN', N'name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'排序',
'SCHEMA', N'dbo',
'TABLE', N'sys_power',
'COLUMN', N'sort'
GO

EXEC sp_addextendedproperty
'MS_Description', N'类型（0 菜单，1 路由 ，2 权限）',
'SCHEMA', N'dbo',
'TABLE', N'sys_power',
'COLUMN', N'type'
GO

EXEC sp_addextendedproperty
'MS_Description', N'接口地址',
'SCHEMA', N'dbo',
'TABLE', N'sys_power',
'COLUMN', N'url'
GO

EXEC sp_addextendedproperty
'MS_Description', N'资源路径',
'SCHEMA', N'dbo',
'TABLE', N'sys_power',
'COLUMN', N'path'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否缓存',
'SCHEMA', N'dbo',
'TABLE', N'sys_power',
'COLUMN', N'cache'
GO

EXEC sp_addextendedproperty
'MS_Description', N'图标',
'SCHEMA', N'dbo',
'TABLE', N'sys_power',
'COLUMN', N'icon'
GO

EXEC sp_addextendedproperty
'MS_Description', N'父级id',
'SCHEMA', N'dbo',
'TABLE', N'sys_power',
'COLUMN', N'parent_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'所有父级id',
'SCHEMA', N'dbo',
'TABLE', N'sys_power',
'COLUMN', N'parent_ids'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间（秒）',
'SCHEMA', N'dbo',
'TABLE', N'sys_power',
'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改时间（秒）',
'SCHEMA', N'dbo',
'TABLE', N'sys_power',
'COLUMN', N'update_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'sys_power',
'COLUMN', N'remarks'
GO

EXEC sp_addextendedproperty
'MS_Description', N'系统权限表',
'SCHEMA', N'dbo',
'TABLE', N'sys_power'
GO


CREATE TABLE sys_role (
 [id] nvarchar(36) NOT NULL,
 [name] nvarchar(50) NOT NULL,
 [state] tinyint DEFAULT 1 NOT NULL,
 [create_time] bigint NULL,
 [update_time] bigint NULL,
 [remarks] nvarchar(255) NULL
)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'sys_role',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'名称',
'SCHEMA', N'dbo',
'TABLE', N'sys_role',
'COLUMN', N'name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'状态',
'SCHEMA', N'dbo',
'TABLE', N'sys_role',
'COLUMN', N'state'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间（秒）',
'SCHEMA', N'dbo',
'TABLE', N'sys_role',
'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改时间（秒）',
'SCHEMA', N'dbo',
'TABLE', N'sys_role',
'COLUMN', N'update_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'sys_role',
'COLUMN', N'remarks'
GO

EXEC sp_addextendedproperty
'MS_Description', N'系统角色',
'SCHEMA', N'dbo',
'TABLE', N'sys_role'
GO


CREATE TABLE sys_role_power (
 [power_id] nvarchar(36) NOT NULL,
 [role_id] nvarchar(36) NOT NULL
)
GO

EXEC sp_addextendedproperty
'MS_Description', N'权限编号',
'SCHEMA', N'dbo',
'TABLE', N'sys_role_power',
'COLUMN', N'power_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色编号',
'SCHEMA', N'dbo',
'TABLE', N'sys_role_power',
'COLUMN', N'role_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'系统角色权限中间表',
'SCHEMA', N'dbo',
'TABLE', N'sys_role_power'
GO



CREATE TABLE sys_user (
 [id] nvarchar(36) NOT NULL,
 [name] nvarchar(50) NOT NULL,
 [state] tinyint DEFAULT 1 NOT NULL,
 [type] tinyint DEFAULT 0 NOT NULL,
 [mobile] nvarchar(11) NOT NULL,
 [nick_name] nvarchar(50) NULL,
 [password] nvarchar(64) NOT NULL,
 [login_time] bigint NULL,
 [create_time] bigint NULL,
 [update_time] bigint NULL,
 [remarks] nvarchar(255) NULL
)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'昵称',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'nick_name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户状态(字典值state)',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'state'
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户类型（字典值sys_user_type）',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'type'
GO

EXEC sp_addextendedproperty
'MS_Description', N'手机号',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'mobile'
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户账号',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'密码',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'password'
GO

EXEC sp_addextendedproperty
'MS_Description', N'登录时间（秒）',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'login_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间（秒）',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改时间（秒）',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'update_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'remarks'
GO

EXEC sp_addextendedproperty
'MS_Description', N'系统用户表',
'SCHEMA', N'dbo',
'TABLE', N'sys_user'
GO



CREATE TABLE [dbo].[sys_user_role] (
 [user_id] nvarchar(36) NOT NULL,
 [role_id] nvarchar(36) NOT NULL
)
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户编号',
'SCHEMA', N'dbo',
'TABLE', N'sys_user_role',
'COLUMN', N'user_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色编号',
'SCHEMA', N'dbo',
'TABLE', N'sys_user_role',
'COLUMN', N'role_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'系统用户角色中间表',
'SCHEMA', N'dbo',
'TABLE', N'sys_user_role'
GO

CREATE TABLE t_database_info (
 [id] nvarchar(36) NOT NULL,
 [name] nvarchar(50) NULL,
 [database_type] nvarchar(20) NOT NULL,
 [username] nvarchar(50) NOT NULL,
 [password] nvarchar(50) NOT NULL,
 [ip_port] nvarchar(30) NOT NULL,
 [other_params] nvarchar(255) NULL,
 [create_time] bigint NULL,
 [update_time] bigint NULL,
 [remarks] nvarchar(255) NULL
)
GO

EXEC sp_addextendedproperty
'MS_Description', N'编号',
'SCHEMA', N'dbo',
'TABLE', N't_database_info',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'名称',
'SCHEMA', N'dbo',
'TABLE', N't_database_info',
'COLUMN', N'name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'数据库类型',
'SCHEMA', N'dbo',
'TABLE', N't_database_info',
'COLUMN', N'database_type'
GO

EXEC sp_addextendedproperty
'MS_Description', N'数据库用户名',
'SCHEMA', N'dbo',
'TABLE', N't_database_info',
'COLUMN', N'username'
GO

EXEC sp_addextendedproperty
'MS_Description', N'数据库密码',
'SCHEMA', N'dbo',
'TABLE', N't_database_info',
'COLUMN', N'password'
GO

EXEC sp_addextendedproperty
'MS_Description', N'ip和端口',
'SCHEMA', N'dbo',
'TABLE', N't_database_info',
'COLUMN', N'ip_port'
GO

EXEC sp_addextendedproperty
'MS_Description', N'数据库其他参数（连接数据库时额外配置）',
'SCHEMA', N'dbo',
'TABLE', N't_database_info',
'COLUMN', N'other_params'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间（秒）',
'SCHEMA', N'dbo',
'TABLE', N't_database_info',
'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改时间（秒）',
'SCHEMA', N'dbo',
'TABLE', N't_database_info',
'COLUMN', N'update_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N't_database_info',
'COLUMN', N'remarks'
GO

EXEC sp_addextendedproperty
'MS_Description', N'数据库管理',
'SCHEMA', N'dbo',
'TABLE', N't_database_info'
GO

/**
 设置主键
 */
ALTER TABLE sys_dict ADD PRIMARY KEY CLUSTERED ([id])
GO
ALTER TABLE sys_dict_details ADD PRIMARY KEY CLUSTERED ([id])
GO
ALTER TABLE sys_log ADD PRIMARY KEY CLUSTERED ([id])
GO
ALTER TABLE sys_power ADD PRIMARY KEY CLUSTERED ([id])
GO
ALTER TABLE sys_role ADD PRIMARY KEY CLUSTERED ([id])
GO
ALTER TABLE sys_role_power ADD PRIMARY KEY CLUSTERED ([power_id], [role_id])
GO
ALTER TABLE sys_user ADD PRIMARY KEY CLUSTERED ([id])
GO
ALTER TABLE sys_user_role ADD PRIMARY KEY CLUSTERED ([user_id], [role_id])
GO
ALTER TABLE t_database_info ADD PRIMARY KEY CLUSTERED ([id])
GO
/**
 设置索引
 */
CREATE NONCLUSTERED INDEX [nk_url] ON sys_power ([url] ASC)
GO
CREATE NONCLUSTERED INDEX [nk_path] ON sys_power ([path] ASC)
GO
CREATE NONCLUSTERED INDEX [nk_name] ON sys_user ([name] ASC)
GO
/**
 设置唯一键
 */
 alter table sys_user add constraint uk_name unique (name)
 GO
 alter table sys_dict add constraint uk_code unique (code)
 GO
/**
 初始化数据
 */
INSERT INTO sys_user VALUES ('1', 'zero', '1', '1', '15397608105', 'zero', 'd02c4c4cde7ae76252540d116a40f23a', null,1591545600, 1591545600, '初始化用户');
INSERT INTO sys_role VALUES ('1', '管理员',1, 1591545600, 1591545600, '初始化角色');
INSERT INTO sys_user_role VALUES ('1', '1');

INSERT INTO t_database_info  VALUES ('1', 'localhost（mysql）', 'MYSQL', 'root', 'admin', 'localhost:3306', '?characterEncoding=utf8&useSSL=false&serverTimezone=GMT%2B8&nullNamePatternMatchesAll=true', 1591545600, 1591545600, 'MYSQL配置');
INSERT INTO t_database_info  VALUES ('2', 'sql_server', 'SQL_SERVER', 'sa', 'zero', 'localhost:1433', '', 1591545600, 1591545600, 'SQL_SERVER配置');
INSERT INTO t_database_info  VALUES ('3', 'oracle', 'ORACLE', 'zero', 'zero', 'localhost:1521', ':orcl', 1591545600, 1591545600, 'ORACLE配置');

INSERT INTO sys_dict  VALUES ('1','state', '状态',1591545600, 1591545600,'备注');
INSERT INTO sys_dict  VALUES ('2','sys_user_type', '系统用户类型',1591545600, 1591545600,'备注');
INSERT INTO sys_dict  VALUES ('3','sys_power_type', '权限类型',1591545600, 1591545600,'备注');

INSERT INTO sys_dict_details VALUES ('1', 'state', '禁用', 1, '0',1591545600, 1591545600,'备注');
INSERT INTO sys_dict_details VALUES ('2', 'state', '启用', 0, '1',1591545600, 1591545600,'备注');
INSERT INTO sys_dict_details  VALUES ('3', 'sys_user_type', '普通用户', 0, '0',1591545600, 1591545600,'备注');
INSERT INTO sys_dict_details  VALUES ('4', 'sys_user_type', '管理用户', 1, '1',1591545600, 1591545600,'备注');
INSERT INTO sys_dict_details VALUES ('5', 'sys_user_type', '超级用户', 2, '2',1591545600, 1591545600,'备注');
INSERT INTO sys_dict_details VALUES ('6', 'sys_power_type', '目录', 0, '0',1591545600, 1591545600,'备注');
INSERT INTO sys_dict_details VALUES ('7', 'sys_power_type', '菜单', 1, '1',1591545600, 1591545600,'备注');
INSERT INTO sys_dict_details VALUES ('8', 'sys_power_type', '权限', 2, '2',1591545600, 1591545600,'备注');


INSERT INTO sys_power VALUES (N'08bc94ca-1440-43e9-9ee6-65669af355b7', N'系统管理', 1, 0, NULL, NULL,0, N'fa fa-slack', N'00000000-0000-0000-0000-000000000000', N'00000000-0000-0000-0000-000000000000', 1592543029, 1592801150, NULL);
INSERT INTO sys_power VALUES (N'e6780176-ee65-4c59-a94f-68363a3aed7c', N'系统角色', 3, 1, NULL, N'/SysRole',0, N'fa fa-columns', N'08bc94ca-1440-43e9-9ee6-65669af355b7', N'08bc94ca-1440-43e9-9ee6-65669af355b7', 1592797361, 1593509872, NULL);
INSERT INTO sys_power VALUES (N'1aead7fc-5ad9-4366-b330-c49ece7312eb', N'首页', 0, 1, NULL, N'/Index',0, N'fa fa-user', N'00000000-0000-0000-0000-000000000000', N'00000000-0000-0000-0000-000000000000', 1592797449, 1592802535, NULL);
INSERT INTO sys_power VALUES (N'29b86c0f-5871-4006-afff-a3393856c12f', N'系统用户', 1, 1, NULL, N'/SysUser',0, N'fa fa-slack', N'08bc94ca-1440-43e9-9ee6-65669af355b7', N'08bc94ca-1440-43e9-9ee6-65669af355b7', 1592543042, 1593509867, NULL);
INSERT INTO sys_power VALUES (N'353e3161-70ad-41fe-8b78-a2eed77d11f8', N'系统权限', 4, 1, NULL, N'/SysPower',0, N'fa fa-video-camera', N'08bc94ca-1440-43e9-9ee6-65669af355b7', N'08bc94ca-1440-43e9-9ee6-65669af355b7', 1592797340, 1593510654, NULL);
INSERT INTO sys_power VALUES (N'4679429d-bf28-4670-97fb-40f82efb6558', N'用户删除', 3, 2, N'/sysUser/del', NULL,0, NULL, N'29b86c0f-5871-4006-afff-a3393856c12f', N'08bc94ca-1440-43e9-9ee6-65669af355b7,29b86c0f-5871-4006-afff-a3393856c12f', 1593677151, 1593679437, NULL);
INSERT INTO sys_power VALUES (N'49fea647-6eda-4938-ae54-aef56b1e8d67', N'角色修改', 2, 2, N'/sysRole/update', NULL,0, NULL,N'e6780176-ee65-4c59-a94f-68363a3aed7c', N'08bc94ca-1440-43e9-9ee6-65669af355b7,e6780176-ee65-4c59-a94f-68363a3aed7c', 1593679417, 1593679417, NULL);
INSERT INTO sys_power VALUES (N'601c58fa-873a-4dc0-aef5-3fbf3cce6183', N'用户列表', 0, 2, N'/sysUser/pageList', NULL,0, NULL, N'29b86c0f-5871-4006-afff-a3393856c12f', N'08bc94ca-1440-43e9-9ee6-65669af355b7,29b86c0f-5871-4006-afff-a3393856c12f', 1593679820, 1593679820, NULL);
INSERT INTO sys_power VALUES (N'6357250c-3526-4145-86ba-cbe4f3255fdb', N'用户修改', 2, 2, N'/sysUser/update', NULL,0, NULL, N'29b86c0f-5871-4006-afff-a3393856c12f', N'08bc94ca-1440-43e9-9ee6-65669af355b7,29b86c0f-5871-4006-afff-a3393856c12f', 1593677132, 1593677132, NULL);
INSERT INTO sys_power VALUES (N'7d199588-24de-4909-a95f-2af5b2016199', N'权限新增', 1, 2, N'/sysPower/add', NULL,0, NULL, N'353e3161-70ad-41fe-8b78-a2eed77d11f8', N'08bc94ca-1440-43e9-9ee6-65669af355b7,353e3161-70ad-41fe-8b78-a2eed77d11f8', 1593679490, 1593679490, NULL);
INSERT INTO sys_power VALUES (N'b16e14aa-0931-4fe4-81a3-50dc450aced9', N'权限删除', 3, 2, N'/sysPower/del', NULL,0, NULL, N'353e3161-70ad-41fe-8b78-a2eed77d11f8', N'08bc94ca-1440-43e9-9ee6-65669af355b7,353e3161-70ad-41fe-8b78-a2eed77d11f8', 1593679532, 1593679532, NULL);
INSERT INTO sys_power VALUES (N'd516edcb-4e6f-46c5-ae20-910f4d841d8a', N'角色列表', 0, 2, N'/sysRole/pageList', NULL,0, NULL, N'e6780176-ee65-4c59-a94f-68363a3aed7c', N'08bc94ca-1440-43e9-9ee6-65669af355b7,e6780176-ee65-4c59-a94f-68363a3aed7c', 1593676661, 1593678434, NULL);
INSERT INTO sys_power VALUES (N'e4f0ed92-f7f8-48da-a4f2-c5e91d218276', N'角色新增', 1, 2, N'/sysRole/add', NULL,0, NULL, N'e6780176-ee65-4c59-a94f-68363a3aed7c', N'08bc94ca-1440-43e9-9ee6-65669af355b7,e6780176-ee65-4c59-a94f-68363a3aed7c', 1593679391, 1593679398, NULL);
INSERT INTO sys_power VALUES (N'f6fc6d9a-e810-4285-999c-6ae4bf4eaaa6', N'用户新增', 1, 2, N'/sysUser/add', NULL,0, NULL, N'29b86c0f-5871-4006-afff-a3393856c12f', N'08bc94ca-1440-43e9-9ee6-65669af355b7,29b86c0f-5871-4006-afff-a3393856c12f', 1593677105, 1593678377, NULL);
INSERT INTO sys_power VALUES (N'12ff6d23-5ff1-40e0-97d0-41030b5748cf', N'权限修改', 2, 2, N'/sysPower/update', NULL,0, NULL, N'353e3161-70ad-41fe-8b78-a2eed77d11f8', N'08bc94ca-1440-43e9-9ee6-65669af355b7,353e3161-70ad-41fe-8b78-a2eed77d11f8', 1593679507, 1593679507, NULL);
INSERT INTO sys_power VALUES (N'17dddd36-9119-478e-81fd-335886957c5c', N'权限列表', 0, 2, N'/sysPower/tree', NULL,0, NULL, N'353e3161-70ad-41fe-8b78-a2eed77d11f8', N'08bc94ca-1440-43e9-9ee6-65669af355b7,353e3161-70ad-41fe-8b78-a2eed77d11f8', 1593679470, 1593679470, NULL);
INSERT INTO sys_power VALUES (N'07058674-9355-42a4-9835-6277b5afd0e9', N'角色删除', 3, 2, N'/sysRole/del', NULL,0, NULL, N'e6780176-ee65-4c59-a94f-68363a3aed7c', N'08bc94ca-1440-43e9-9ee6-65669af355b7,e6780176-ee65-4c59-a94f-68363a3aed7c', 1593679431, 1593679431, NULL);
INSERT INTO sys_power VALUES (N'702443a6-3da2-4831-a4df-f8d06c6b090e', N'日志列表', 0, 2, N'/sysLog/pageList', NULL, '0', NULL, N'5d3231db-0c69-4603-8716-9305399384b9', N'08bc94ca-1440-43e9-9ee6-65669af355b7,5d3231db-0c69-4603-8716-9305399384b9', 1595922755, 1595922755, NULL);
INSERT INTO sys_power VALUES (N'5d3231db-0c69-4603-8716-9305399384b9', N'系统日志', 5, 1, NULL, N'/SysLog', '0', N'fa fa-slack', N'08bc94ca-1440-43e9-9ee6-65669af355b7', N'08bc94ca-1440-43e9-9ee6-65669af355b7', 1595922730, 1595922730, NULL);
INSERT INTO sys_power VALUES ('87d1d016-d87d-4fb5-8c4e-4df1c02695c4', '开发工具', 2, 0, NULL, NULL, 0, 'fa fa-slack', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', 1597799291, 1597799291, NULL);
INSERT INTO sys_power VALUES ('9e7414c6-934d-4816-8004-2ed354e52a69', '数据库管理', 5, 1, NULL, '/DatabaseInfo', 0, 'fa fa-slack', '87d1d016-d87d-4fb5-8c4e-4df1c02695c4', '87d1d016-d87d-4fb5-8c4e-4df1c02695c4', 1597799336, 1597799336, NULL);
INSERT INTO sys_power VALUES ('d649bde7-cf97-445b-a317-ada9d73e4b4c', '数据库列表', 0, 2, '/databaseInfo/list', NULL, 0, NULL, '9e7414c6-934d-4816-8004-2ed354e52a69', '87d1d016-d87d-4fb5-8c4e-4df1c02695c4,9e7414c6-934d-4816-8004-2ed354e52a69', 1597799381, 1597799381, NULL);
INSERT INTO sys_power VALUES ('30c92a2d-bc5c-46e1-a071-203d4e711c40', '系统字典', 5, 1, NULL, '/SysDict', 0, 'fa fa-video-camera', '08bc94ca-1440-43e9-9ee6-65669af355b7', '08bc94ca-1440-43e9-9ee6-65669af355b7', 1597799432, 1597799432, NULL);
INSERT INTO sys_power VALUES ('9fbe8511-c641-4dd5-8448-de709c627649', '字典列表', 0, 2, '/sysDict/pageList', NULL, 0, NULL, '30c92a2d-bc5c-46e1-a071-203d4e711c40', '08bc94ca-1440-43e9-9ee6-65669af355b7,30c92a2d-bc5c-46e1-a071-203d4e711c40', 1597799486, 1597799486, NULL);

INSERT INTO sys_role_power VALUES (N'07058674-9355-42a4-9835-6277b5afd0e9', N'1');
INSERT INTO sys_role_power VALUES (N'08bc94ca-1440-43e9-9ee6-65669af355b7', N'1');
INSERT INTO sys_role_power VALUES (N'12ff6d23-5ff1-40e0-97d0-41030b5748cf', N'1');
INSERT INTO sys_role_power VALUES (N'17dddd36-9119-478e-81fd-335886957c5c', N'1');
INSERT INTO sys_role_power VALUES (N'1aead7fc-5ad9-4366-b330-c49ece7312eb', N'1');
INSERT INTO sys_role_power VALUES (N'29b86c0f-5871-4006-afff-a3393856c12f', N'1');
INSERT INTO sys_role_power VALUES (N'353e3161-70ad-41fe-8b78-a2eed77d11f8', N'1');
INSERT INTO sys_role_power VALUES (N'4679429d-bf28-4670-97fb-40f82efb6558', N'1');
INSERT INTO sys_role_power VALUES (N'49fea647-6eda-4938-ae54-aef56b1e8d67', N'1');
INSERT INTO sys_role_power VALUES (N'601c58fa-873a-4dc0-aef5-3fbf3cce6183', N'1');
INSERT INTO sys_role_power VALUES (N'6357250c-3526-4145-86ba-cbe4f3255fdb', N'1');
INSERT INTO sys_role_power VALUES (N'7d199588-24de-4909-a95f-2af5b2016199', N'1');
INSERT INTO sys_role_power VALUES (N'b16e14aa-0931-4fe4-81a3-50dc450aced9', N'1');
INSERT INTO sys_role_power VALUES (N'd516edcb-4e6f-46c5-ae20-910f4d841d8a', N'1');
INSERT INTO sys_role_power VALUES (N'e4f0ed92-f7f8-48da-a4f2-c5e91d218276', N'1');
INSERT INTO sys_role_power VALUES (N'e6780176-ee65-4c59-a94f-68363a3aed7c', N'1');
INSERT INTO sys_role_power VALUES (N'f6fc6d9a-e810-4285-999c-6ae4bf4eaaa6', N'1');
INSERT INTO sys_role_power VALUES (N'702443a6-3da2-4831-a4df-f8d06c6b090e', N'1');
INSERT INTO sys_role_power VALUES (N'5d3231db-0c69-4603-8716-9305399384b9', N'1');
INSERT INTO sys_role_power VALUES (N'87d1d016-d87d-4fb5-8c4e-4df1c02695c4', N'1');
INSERT INTO sys_role_power VALUES (N'9e7414c6-934d-4816-8004-2ed354e52a69', N'1');
INSERT INTO sys_role_power VALUES (N'd649bde7-cf97-445b-a317-ada9d73e4b4c', N'1');
INSERT INTO sys_role_power VALUES (N'30c92a2d-bc5c-46e1-a071-203d4e711c40', N'1');
INSERT INTO sys_role_power VALUES (N'9fbe8511-c641-4dd5-8448-de709c627649', N'1');

